Vessel billing extract mapping file

You can map additional fields for N4 to extract as part of the vessel billing extract. The field names specified in the mapping file must exactly match the External Tag (case-sensitive) for the N4 field (in the corresponding reporting entity) and have the same data type.

N4 provides:

The field name specified in the value attribute must exactly match the External Tag (case-sensitive) specified for the field in the corresponding reporting entity. If it is not a valid map, N4 does not extract the field. For example, if you want to map a vessel visit flex field, use the External Tag (case-sensitive) specified for the flex field in the Vessel Visit reporting entity.

The following sample billing extract XML mapping displays the format of the available flex fields that you can use to map existing N4 fields. The flexfield-mappings block consists of flex fields of type String, Date, and Long. For example, the bexmFlexString01 flex field is of the type string and you can only map it to N4 fields that are of the type String.

<?xml version="1.0" encoding="UTF-8"?>

<!--Define the billing flex field mapping here. Billing extract uses this file to store the actual field values to the flex fields in the argo_chargeable_marine_events table. It is the editor's responsibility to type the correct flex field value. Editor should assign the string, date, long column value selection appropriately. If it is not a valid column name in N4, the column will not be extracted.-->

 

<flexfield-mappings>

    <flexfield-mapping id="bexmFlexString01" value="IbVesselCaptain"/>

    <flexfield-mapping id="bexmFlexString02" value=""/>

    <flexfield-mapping id="bexmFlexString03" value=""/>

    <flexfield-mapping id="bexmFlexString04" value=""/>

    <flexfield-mapping id="bexmFlexString05" value=""/>

    <flexfield-mapping id="bexmFlexDate01" value=""/>

    <flexfield-mapping id="bexmFlexDate02" value=""/>

    <flexfield-mapping id="bexmFlexDate03" value=""/>

    <flexfield-mapping id="bexmFlexDate04" value=""/>

    <flexfield-mapping id="bexmFlexDate05" value=""/>

    <flexfield-mapping id="bexmFlexLong01" value=""/>

    <flexfield-mapping id="bexmFlexLong02" value=""/>

    <flexfield-mapping id="bexmFlexLong03" value=""/>

    <flexfield-mapping id="bexmFlexLong04" value=""/>

    <flexfield-mapping id="bexmFlexLong05" value=""/>

    <flexfield-mapping id="bexmFlexDouble01" value=""/>

    <flexfield-mapping id="bexmFlexDouble02" value=""/>

    <flexfield-mapping id="bexmFlexDouble03" value=""/>

    <flexfield-mapping id="bexmFlexDouble04" value=""/>

    <flexfield-mapping id="bexmFlexDouble05" value=""/>

</flexfield-mappings>

To load a user-defined billing extract mapping file:

  1. Create the billing extract mapping file using any XML editor.

You can also copy the sample mapping file shown above and edit the fields you want to extract.

  1. In the Administration Settings Settings view, select INVBILLING005 (BILLING_EXTRACT_USE_EVENT_TYPE_ID) (on page 1) and click .

  2. In the Edit Configuration form, select the scope level at which you want to add the billing extract mapping file.

All the lower scope levels inherit the mapping file. For more information, see Edit Configuration form.

  1. Click Override to override the existing configuration for the INVBILLING005 setting.

  2. Click Import File to import the billing extract mapping file.

  3. In the Import XML Configuration dialog box, select the billing extract mapping file and click Open.

The text field displays --loaded-- to indicate that the mapping file is associated at the selected scope level.

To remove a loaded file, click Clear.

  1. Click Save.